Data Profiling Report

Brought to you by YData

Dataset statistics

Number of variables	17
Number of observations	2875
Missing cells	925
Missing cells (%)	1.9%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	4.5 MiB
Average record size in memory	1.6 KiB

Variable types

Numeric	5
Text	5
Categorical	6
DateTime	1

Alerts

`State` has constant value "IL"	Constant
`Facility Type` is highly imbalanced (68.9%)	Imbalance
`Risk` is highly imbalanced (61.2%)	Imbalance
`City` is highly imbalanced (98.6%)	Imbalance
`Violations` has 855 (29.7%) missing values	Missing
`Inspection ID` has unique values	Unique

Reproduction

Analysis started	2025-04-14 22:58:35.432311
Analysis finished	2025-04-14 22:58:41.354894
Duration	5.92 seconds
Software version	ydata-profiling vv4.16.1
Download configuration	config.json

Inspection ID
Real number (ℝ)

Unique

Distinct	2875
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2611397.4

Minimum	2609901
Maximum	2613137
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	22.6 KiB

Quantile statistics

Minimum	2609901
5-th percentile	2610047.7
Q1	2610625.5
median	2611346
Q3	2612150.5
95-th percentile	2612895.3
Maximum	2613137
Range	3236
Interquartile range (IQR)	1525

Descriptive statistics

Standard deviation	901.06044
Coefficient of variation (CV)	0.00034504914
Kurtosis	-1.1217216
Mean	2611397.4
Median Absolute Deviation (MAD)	759
Skewness	0.14088144
Sum	7.5077676 × 10⁹
Variance	811909.92
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2610068	1	< 0.1%
2609909	1	< 0.1%
2609927	1	< 0.1%
2610482	1	< 0.1%
2610081	1	< 0.1%
2610172	1	< 0.1%
2610336	1	< 0.1%
2611120	1	< 0.1%
2610622	1	< 0.1%
2610361	1	< 0.1%
Other values (2865)	2865	99.7%

Value	Count	Frequency (%)
2609901	1	< 0.1%
2609903	1	< 0.1%
2609904	1	< 0.1%
2609905	1	< 0.1%
2609906	1	< 0.1%
2609907	1	< 0.1%
2609908	1	< 0.1%
2609909	1	< 0.1%
2609910	1	< 0.1%
2609911	1	< 0.1%

Value	Count	Frequency (%)
2613137	1	< 0.1%
2613134	1	< 0.1%
2613132	1	< 0.1%
2613130	1	< 0.1%
2613121	1	< 0.1%
2613120	1	< 0.1%
2613119	1	< 0.1%
2613118	1	< 0.1%
2613117	1	< 0.1%
2613115	1	< 0.1%

DBA Name
Text

Distinct	1950
Distinct (%)	67.8%
Missing	0
Missing (%)	0.0%
Memory size	213.2 KiB

Length

Max length	56
Median length	38
Mean length	18.899478
Min length	2

Characters and Unicode

Total characters	54336
Distinct characters	77
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1346 ?
Unique (%)	46.8%

Sample

1st row	HAPPY MARKET
2nd row	SAT KAIVAL FOOD INC/SUBWAY
3rd row	DANCEN GRILL RESTAURANT, INC.
4th row	MARYS TAQUERIA AND GROCERY STORE, INC.
5th row	KOTO

Value	Count	Frequency (%)
	277	3.1%
inc	247	2.8%
restaurant	159	1.8%
school	134	1.5%
chicago	133	1.5%
the	120	1.4%
elementary	116	1.3%
subway	112	1.3%
llc	99	1.1%
cafe	95	1.1%
Other values (2518)	7315	83.1%

Most occurring characters

Value	Count	Frequency (%)
	5970	11.0%
A	4622	8.5%
E	4381	8.1%
O	3121	5.7%
R	3077	5.7%
I	3047	5.6%
S	2935	5.4%
N	2934	5.4%
T	2626	4.8%
C	2603	4.8%
Other values (67)	19020	35.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	54336	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	5970	11.0%
A	4622	8.5%
E	4381	8.1%
O	3121	5.7%
R	3077	5.7%
I	3047	5.6%
S	2935	5.4%
N	2934	5.4%
T	2626	4.8%
C	2603	4.8%
Other values (67)	19020	35.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	54336	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	5970	11.0%
A	4622	8.5%
E	4381	8.1%
O	3121	5.7%
R	3077	5.7%
I	3047	5.6%
S	2935	5.4%
N	2934	5.4%
T	2626	4.8%
C	2603	4.8%
Other values (67)	19020	35.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	54336	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	5970	11.0%
A	4622	8.5%
E	4381	8.1%
O	3121	5.7%
R	3077	5.7%
I	3047	5.6%
S	2935	5.4%
N	2934	5.4%
T	2626	4.8%
C	2603	4.8%
Other values (67)	19020	35.0%

AKA Name
Text

Distinct	1903
Distinct (%)	66.3%
Missing	6
Missing (%)	0.2%
Memory size	209.5 KiB

Length

Max length	56
Median length	40
Mean length	17.671314
Min length	2

Characters and Unicode

Total characters	50699
Distinct characters	76
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1292 ?
Unique (%)	45.0%

Sample

1st row	HAPPY MARKET
2nd row	SAT KAIVAL FOOD INC/SUBWAY
3rd row	DANCEN
4th row	MARYS FOOD AND GROCERY STORE
5th row	KOTO

Value	Count	Frequency (%)
	251	3.1%
school	151	1.8%
restaurant	141	1.7%
elementary	124	1.5%
the	118	1.4%
subway	113	1.4%
cafe	98	1.2%
grill	87	1.1%
inc	85	1.0%
chicago	80	1.0%
Other values (2454)	6948	84.8%

Most occurring characters

Value	Count	Frequency (%)
	5372	10.6%
A	4376	8.6%
E	4304	8.5%
O	2961	5.8%
R	2887	5.7%
S	2868	5.7%
I	2772	5.5%
N	2611	5.2%
T	2480	4.9%
C	2240	4.4%
Other values (66)	17828	35.2%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	50699	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	5372	10.6%
A	4376	8.6%
E	4304	8.5%
O	2961	5.8%
R	2887	5.7%
S	2868	5.7%
I	2772	5.5%
N	2611	5.2%
T	2480	4.9%
C	2240	4.4%
Other values (66)	17828	35.2%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	50699	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	5372	10.6%
A	4376	8.6%
E	4304	8.5%
O	2961	5.8%
R	2887	5.7%
S	2868	5.7%
I	2772	5.5%
N	2611	5.2%
T	2480	4.9%
C	2240	4.4%
Other values (66)	17828	35.2%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	50699	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	5372	10.6%
A	4376	8.6%
E	4304	8.5%
O	2961	5.8%
R	2887	5.7%
S	2868	5.7%
I	2772	5.5%
N	2611	5.2%
T	2480	4.9%
C	2240	4.4%
Other values (66)	17828	35.2%

License #
Real number (ℝ)

Distinct	2231
Distinct (%)	77.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2153165.9

Minimum	0
Maximum	4080354
Zeros	8
Zeros (%)	0.3%
Negative	0
Negative (%)	0.0%
Memory size	22.6 KiB

Quantile statistics

Minimum	0
5-th percentile	22936.5
Q1	1922096
median	2555533
Q3	2900652
95-th percentile	3010517
Maximum	4080354
Range	4080354
Interquartile range (IQR)	978556

Descriptive statistics

Standard deviation	1032216.4
Coefficient of variation (CV)	0.47939471
Kurtosis	0.1473032
Mean	2153165.9
Median Absolute Deviation (MAD)	400519
Skewness	-1.2271141
Sum	6.1903521 × 10⁹
Variance	1.0654706 × 10¹²
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8	0.3%
2196054	5	0.2%
2890832	4	0.1%
47091	4	0.1%
1362	4	0.1%
2803058	4	0.1%
2891013	4	0.1%
2469629	4	0.1%
2807913	3	0.1%
2373870	3	0.1%
Other values (2221)	2832	98.5%

Value	Count	Frequency (%)
0	8	0.3%
747	2	0.1%
1206	1	< 0.1%
1325	1	< 0.1%
1362	4	0.1%
1366	1	< 0.1%
1372	1	< 0.1%
1375	1	< 0.1%
1387	1	< 0.1%
1392	1	< 0.1%

Value	Count	Frequency (%)
4080354	1	< 0.1%
4080337	1	< 0.1%
4080235	1	< 0.1%
4076132	1	< 0.1%
4074376	1	< 0.1%
4074227	1	< 0.1%
4067403	1	< 0.1%
3931571	1	< 0.1%
3931156	1	< 0.1%
3930926	1	< 0.1%

Facility Type
Categorical

Imbalance

Distinct	36
Distinct (%)	1.3%
Missing	23
Missing (%)	0.8%
Memory size	189.8 KiB

Restaurant	2068
School	331
Grocery Store	199
Children's Services Facility	74
Daycare Above and Under 2 Years	31
Other values (31)	149

Length

Max length	38
Median length	10
Mean length	10.575386
Min length	5

Characters and Unicode

Total characters	30161
Distinct characters	54
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12 ?
Unique (%)	0.4%

Sample

1st row	Grocery Store
2nd row	Restaurant
3rd row	Restaurant
4th row	Restaurant
5th row	Restaurant

Common Values

Value	Count	Frequency (%)
Restaurant	2068	71.9%
School	331	11.5%
Grocery Store	199	6.9%
Children's Services Facility	74	2.6%
Daycare Above and Under 2 Years	31	1.1%
Bakery	29	1.0%
Daycare (2 - 6 Years)	24	0.8%
Long Term Care	13	0.5%
Mobile Food Preparer	12	0.4%
Liquor	12	0.4%
Other values (26)	59	2.1%
(Missing)	23	0.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
restaurant	2068	58.3%
school	335	9.4%
store	202	5.7%
grocery	200	5.6%
facility	75	2.1%
children's	74	2.1%
services	74	2.1%
daycare	60	1.7%
years	58	1.6%
2	58	1.6%
Other values (48)	343	9.7%

Most occurring characters

Value	Count	Frequency (%)
a	4486	14.9%
t	4426	14.7%
r	3084	10.2%
e	2994	9.9%
s	2285	7.6%
n	2245	7.4%
R	2097	7.0%
u	2082	6.9%
o	1171	3.9%
c	741	2.5%
Other values (44)	4550	15.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	30161	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
a	4486	14.9%
t	4426	14.7%
r	3084	10.2%
e	2994	9.9%
s	2285	7.6%
n	2245	7.4%
R	2097	7.0%
u	2082	6.9%
o	1171	3.9%
c	741	2.5%
Other values (44)	4550	15.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	30161	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
a	4486	14.9%
t	4426	14.7%
r	3084	10.2%
e	2994	9.9%
s	2285	7.6%
n	2245	7.4%
R	2097	7.0%
u	2082	6.9%
o	1171	3.9%
c	741	2.5%
Other values (44)	4550	15.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	30161	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
a	4486	14.9%
t	4426	14.7%
r	3084	10.2%
e	2994	9.9%
s	2285	7.6%
n	2245	7.4%
R	2097	7.0%
u	2082	6.9%
o	1171	3.9%
c	741	2.5%
Other values (44)	4550	15.1%

Risk
Categorical

Imbalance

Distinct	4
Distinct (%)	0.1%
Missing	3
Missing (%)	0.1%
Memory size	197.1 KiB

Risk 1 (High)	2422
Risk 2 (Medium)	308
Risk 3 (Low)	138
All	4

Length

Max length	15
Median length	13
Mean length	13.152507
Min length	3

Characters and Unicode

Total characters	37774
Distinct characters	23
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Risk 2 (Medium)
2nd row	Risk 1 (High)
3rd row	Risk 1 (High)
4th row	Risk 1 (High)
5th row	Risk 1 (High)

Common Values

Value	Count	Frequency (%)
Risk 1 (High)	2422	84.2%
Risk 2 (Medium)	308	10.7%
Risk 3 (Low)	138	4.8%
All	4	0.1%
(Missing)	3	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
risk	2868	33.3%
1	2422	28.1%
high	2422	28.1%
2	308	3.6%
medium	308	3.6%
3	138	1.6%
low	138	1.6%
all	4	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
	5736	15.2%
i	5598	14.8%
R	2868	7.6%
s	2868	7.6%
k	2868	7.6%
(	2868	7.6%
)	2868	7.6%
1	2422	6.4%
H	2422	6.4%
g	2422	6.4%
Other values (13)	4834	12.8%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	37774	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	5736	15.2%
i	5598	14.8%
R	2868	7.6%
s	2868	7.6%
k	2868	7.6%
(	2868	7.6%
)	2868	7.6%
1	2422	6.4%
H	2422	6.4%
g	2422	6.4%
Other values (13)	4834	12.8%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	37774	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	5736	15.2%
i	5598	14.8%
R	2868	7.6%
s	2868	7.6%
k	2868	7.6%
(	2868	7.6%
)	2868	7.6%
1	2422	6.4%
H	2422	6.4%
g	2422	6.4%
Other values (13)	4834	12.8%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	37774	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	5736	15.2%
i	5598	14.8%
R	2868	7.6%
s	2868	7.6%
k	2868	7.6%
(	2868	7.6%
)	2868	7.6%
1	2422	6.4%
H	2422	6.4%
g	2422	6.4%
Other values (13)	4834	12.8%

Address
Text

Distinct	1971
Distinct (%)	68.6%
Missing	0
Missing (%)	0.0%
Memory size	210.5 KiB

Length

Max length	36
Median length	31
Mean length	17.91687
Min length	10

Characters and Unicode

Total characters	51511
Distinct characters	68
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1322 ?
Unique (%)	46.0%

Sample

1st row	2334 S WENTWORTH AVE
2nd row	1916 S STATE ST
3rd row	5114 N LINCOLN AVE
4th row	1901 S CANALPORT AVE
5th row	258 W 31ST ST

Value	Count	Frequency (%)
ave	1430	12.2%
w	1136	9.7%
st	922	7.9%
n	856	7.3%
s	660	5.7%
e	222	1.9%
rd	204	1.7%
milwaukee	91	0.8%
north	82	0.7%
western	80	0.7%
Other values (2080)	5993	51.3%

Most occurring characters

Value	Count	Frequency (%)
	8817	17.1%
E	3479	6.8%
A	3131	6.1%
S	2549	4.9%
N	2300	4.5%
1	2204	4.3%
T	2076	4.0%
0	1789	3.5%
R	1770	3.4%
V	1720	3.3%
Other values (58)	21676	42.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	51511	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	8817	17.1%
E	3479	6.8%
A	3131	6.1%
S	2549	4.9%
N	2300	4.5%
1	2204	4.3%
T	2076	4.0%
0	1789	3.5%
R	1770	3.4%
V	1720	3.3%
Other values (58)	21676	42.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	51511	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	8817	17.1%
E	3479	6.8%
A	3131	6.1%
S	2549	4.9%
N	2300	4.5%
1	2204	4.3%
T	2076	4.0%
0	1789	3.5%
R	1770	3.4%
V	1720	3.3%
Other values (58)	21676	42.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	51511	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	8817	17.1%
E	3479	6.8%
A	3131	6.1%
S	2549	4.9%
N	2300	4.5%
1	2204	4.3%
T	2076	4.0%
0	1789	3.5%
R	1770	3.4%
V	1720	3.3%
Other values (58)	21676	42.1%

City
Categorical

Imbalance

Distinct	3
Distinct (%)	0.1%
Missing	2
Missing (%)	0.1%
Memory size	179.8 KiB

CHICAGO	2867
Chicago	5
chicago	1

Length

Max length	7
Median length	7
Mean length	7
Min length	7

Characters and Unicode

Total characters	20111
Distinct characters	12
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	CHICAGO
2nd row	CHICAGO
3rd row	CHICAGO
4th row	CHICAGO
5th row	CHICAGO

Common Values

Value	Count	Frequency (%)
CHICAGO	2867	99.7%
Chicago	5	0.2%
chicago	1	< 0.1%
(Missing)	2	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
chicago	2873	100.0%

Most occurring characters

Value	Count	Frequency (%)
C	5739	28.5%
H	2867	14.3%
I	2867	14.3%
A	2867	14.3%
G	2867	14.3%
O	2867	14.3%
c	7	< 0.1%
h	6	< 0.1%
i	6	< 0.1%
a	6	< 0.1%
Other values (2)	12	0.1%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	20111	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
C	5739	28.5%
H	2867	14.3%
I	2867	14.3%
A	2867	14.3%
G	2867	14.3%
O	2867	14.3%
c	7	< 0.1%
h	6	< 0.1%
i	6	< 0.1%
a	6	< 0.1%
Other values (2)	12	0.1%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	20111	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
C	5739	28.5%
H	2867	14.3%
I	2867	14.3%
A	2867	14.3%
G	2867	14.3%
O	2867	14.3%
c	7	< 0.1%
h	6	< 0.1%
i	6	< 0.1%
a	6	< 0.1%
Other values (2)	12	0.1%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	20111	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
C	5739	28.5%
H	2867	14.3%
I	2867	14.3%
A	2867	14.3%
G	2867	14.3%
O	2867	14.3%
c	7	< 0.1%
h	6	< 0.1%
i	6	< 0.1%
a	6	< 0.1%
Other values (2)	12	0.1%

State
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	165.8 KiB

IL	2875

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	5750
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	IL
2nd row	IL
3rd row	IL
4th row	IL
5th row	IL

Common Values

Value	Count	Frequency (%)
IL	2875	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
il	2875	100.0%

Most occurring characters

Value	Count	Frequency (%)
I	2875	50.0%
L	2875	50.0%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	5750	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
I	2875	50.0%
L	2875	50.0%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	5750	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
I	2875	50.0%
L	2875	50.0%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	5750	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
I	2875	50.0%
L	2875	50.0%

Zip
Real number (ℝ)

Distinct	57
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	60630.661

Minimum	60601
Maximum	60707
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	22.6 KiB

Quantile statistics

Minimum	60601
5-th percentile	60607
Q1	60615
median	60628
Q3	60642
95-th percentile	60659
Maximum	60707
Range	106
Interquartile range (IQR)	27

Descriptive statistics

Standard deviation	19.653948
Coefficient of variation (CV)	0.00032415856
Kurtosis	2.4707247
Mean	60630.661
Median Absolute Deviation (MAD)	13
Skewness	1.1836451
Sum	1.7431315 × 10⁸
Variance	386.27767
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
60608	102	3.5%
60611	101	3.5%
60618	101	3.5%
60639	101	3.5%
60625	92	3.2%
60607	89	3.1%
60634	89	3.1%
60622	86	3.0%
60659	80	2.8%
60620	77	2.7%
Other values (47)	1957	68.1%

Value	Count	Frequency (%)
60601	26	0.9%
60602	15	0.5%
60603	11	0.4%
60604	7	0.2%
60605	27	0.9%
60606	20	0.7%
60607	89	3.1%
60608	102	3.5%
60609	44	1.5%
60610	51	1.8%

Value	Count	Frequency (%)
60707	57	2.0%
60666	25	0.9%
60661	12	0.4%
60660	24	0.8%
60659	80	2.8%
60657	73	2.5%
60656	17	0.6%
60655	28	1.0%
60654	52	1.8%
60653	29	1.0%

Inspection Date
Date

Distinct	42
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Memory size	22.6 KiB

Minimum	2025-01-02 00:00:00
Maximum	2025-03-05 00:00:00
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=42)

Inspection Type
Categorical

Distinct	10
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	188.7 KiB

Canvass	1532
License	369
Canvass Re-Inspection	350
Complaint	315
Non-Inspection	131
Other values (5)	178

Length

Max length	23
Median length	7
Mean length	10.160696
Min length	7

Characters and Unicode

Total characters	29212
Distinct characters	25
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	Canvass
2nd row	Canvass
3rd row	Non-Inspection
4th row	Canvass
5th row	Canvass

Common Values

Value	Count	Frequency (%)
Canvass	1532	53.3%
License	369	12.8%
Canvass Re-Inspection	350	12.2%
Complaint	315	11.0%
Non-Inspection	131	4.6%
Complaint Re-Inspection	97	3.4%
License Re-Inspection	58	2.0%
Short Form Complaint	18	0.6%
Recent Inspection	4	0.1%
Not Ready	1	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
canvass	1882	55.0%
re-inspection	505	14.8%
complaint	430	12.6%
license	427	12.5%
non-inspection	131	3.8%
short	18	0.5%
form	18	0.5%
recent	4	0.1%
inspection	4	0.1%
not	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
s	4831	16.5%
a	4195	14.4%
n	4154	14.2%
C	2312	7.9%
e	2008	6.9%
v	1882	6.4%
i	1497	5.1%
o	1238	4.2%
t	1093	3.7%
c	1071	3.7%
Other values (15)	4931	16.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	29212	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
s	4831	16.5%
a	4195	14.4%
n	4154	14.2%
C	2312	7.9%
e	2008	6.9%
v	1882	6.4%
i	1497	5.1%
o	1238	4.2%
t	1093	3.7%
c	1071	3.7%
Other values (15)	4931	16.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	29212	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
s	4831	16.5%
a	4195	14.4%
n	4154	14.2%
C	2312	7.9%
e	2008	6.9%
v	1882	6.4%
i	1497	5.1%
o	1238	4.2%
t	1093	3.7%
c	1071	3.7%
Other values (15)	4931	16.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	29212	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
s	4831	16.5%
a	4195	14.4%
n	4154	14.2%
C	2312	7.9%
e	2008	6.9%
v	1882	6.4%
i	1497	5.1%
o	1238	4.2%
t	1093	3.7%
c	1071	3.7%
Other values (15)	4931	16.9%

Results
Categorical

Distinct	6
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	177.9 KiB

Pass	1649
Fail	569
Pass w/ Conditions	285
No Entry	158
Out of Business	154

Length

Max length	18
Median length	4
Mean length	6.3012174
Min length	4

Characters and Unicode

Total characters	18116
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Pass w/ Conditions
2nd row	Pass
3rd row	No Entry
4th row	Pass
5th row	Pass

Common Values

Value	Count	Frequency (%)
Pass	1649	57.4%
Fail	569	19.8%
Pass w/ Conditions	285	9.9%
No Entry	158	5.5%
Out of Business	154	5.4%
Not Ready	60	2.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
pass	1934	48.7%
fail	569	14.3%
w	285	7.2%
conditions	285	7.2%
no	158	4.0%
entry	158	4.0%
out	154	3.9%
of	154	3.9%
business	154	3.9%
not	60	1.5%

Most occurring characters

Value	Count	Frequency (%)
s	4615	25.5%
a	2563	14.1%
P	1934	10.7%
i	1293	7.1%
	1096	6.0%
o	942	5.2%
n	882	4.9%
t	657	3.6%
F	569	3.1%
l	569	3.1%
Other values (14)	2996	16.5%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	18116	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
s	4615	25.5%
a	2563	14.1%
P	1934	10.7%
i	1293	7.1%
	1096	6.0%
o	942	5.2%
n	882	4.9%
t	657	3.6%
F	569	3.1%
l	569	3.1%
Other values (14)	2996	16.5%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	18116	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
s	4615	25.5%
a	2563	14.1%
P	1934	10.7%
i	1293	7.1%
	1096	6.0%
o	942	5.2%
n	882	4.9%
t	657	3.6%
F	569	3.1%
l	569	3.1%
Other values (14)	2996	16.5%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	18116	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
s	4615	25.5%
a	2563	14.1%
P	1934	10.7%
i	1293	7.1%
	1096	6.0%
o	942	5.2%
n	882	4.9%
t	657	3.6%
F	569	3.1%
l	569	3.1%
Other values (14)	2996	16.5%

Violations
Text

Missing

Distinct	2015
Distinct (%)	99.8%
Missing	855
Missing (%)	29.7%
Memory size	2.2 MiB

Length

Max length	7324
Median length	1605
Mean length	1059.3267
Min length	39

Characters and Unicode

Total characters	2139840
Distinct characters	83
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2010 ?
Unique (%)	99.5%

Sample

1st row	2. CITY OF CHICAGO FOOD SERVICE SANITATION CERTIFICATE - Comments: UPON ARRIVAL, OBSERVED NO CITY OF CHICAGO CERTIFIED FOOD MANAGER ON SITE WHILE OPEN AND OPERATING. INSTRUCTED A CITY OF CHICAGO CERTIFIED FOOD MANAGER MUST BE ON SITE AT ALL TIMES WHILE OPEN AND OPERATING. PRIORITY FOUNDATION VIOLATION 7-38-012, CITATION ISSUED \| 10. ADEQUATE HANDWASHING SINKS PROPERLY SUPPLIED AND ACCESSIBLE - Comments: 6-301.14: OBSERVED NO HANDWASHING SIGNS AT EXPOSED HANDSINK IN THE BASEMENT OR IN EMPLOYEE WASHROOM; INSTRUCTED TO PROVIDE. \| 38. INSECTS, RODENTS, & ANIMALS NOT PRESENT - Comments: 6-501.112: OBSERVED DEAD ROACHES INSIDE THE MOP SINK BASIN IN THE BUTCHER AREA, STICKY TRAPS IN BASEMENT FLOORS, ON THE WALL NEAR THE HOOD IN THE BASEMENT PREP AREA. INSTRUCTED TO REMOVE DEAD ROACHES AND MAINTAIN. \| 49. NON-FOOD/FOOD CONTACT SURFACES CLEAN - Comments: OBSERVED SHELF UNDER FOOD PREP TABLE BEHIND BUTCHER AREA WITH RUST. ALSO, OBSERVED DEBRIS ON THE SHELVES IN THE SHOPPING AISLES. INSTRUCTED TO REMOVE RUST AND DEBRIS AND MAKE SURFACE SMOOTH AND EASILY CLEANABLE.
2nd row	36. THERMOMETERS PROVIDED & ACCURATE - Comments: OBSERVED NO AMBIENT AIR THERMOMETER INSIDE THE COLD HOLDING UNITS ON SITE. INSTRUCTED TO PROVIDE AND MAINTAIN. \| 53. TOILET FACILITIES: PROPERLY CONSTRUCTED, SUPPLIED, & CLEANED - Comments: OBSERVED THE TOILET SEAT AND TOILET FIXTURES IN THE WOMEN'S TOILET ROOM IN NEED OF CLEANING. DRIED BODILY FLUID OBSERVED ON THE MENTIONED FIXTURES. INSTRUCTED TO CLEAN AND MAINTAIN.
3rd row	10. ADEQUATE HANDWASHING SINKS PROPERLY SUPPLIED AND ACCESSIBLE - Comments: OBSERVED NO HANDWASHING SIGNAGE AT THE HANDWASHING SINK NEAR THE THREE COMPARTMENT SINK IN THE REAR. INSTRUCTED TO PROVIDE AND MAINTAIN. \| 47. FOOD & NON-FOOD CONTACT SURFACES CLEANABLE, PROPERLY DESIGNED, CONSTRUCTED & USED - Comments: OBSERVED THE LOWER SHELVES UNDER THE FOOD PREP TABLES IN THE REAR FOOD PREP AREA WITH SLIGHT DEBRIS. INSTRUCTED TO REMOVE DEBRIS AND MAINTAIN. \| 51. PLUMBING INSTALLED; PROPER BACKFLOW DEVICES - Comments: OBSERVED NO BACKFLOW PREVENTION DEVICE ON THE ICE MACHINE IN THE REAR FOOD PREP AREA. INSTRUCTED TO INSTALL AN ADEQUATE BACKFLOW PREVENTION DEVICE ON THE ICE MACHINE. \| 53. TOILET FACILITIES: PROPERLY CONSTRUCTED, SUPPLIED, & CLEANED - Comments: OBSERVED NO LID FOR GARBAGE RECEPTACLE IN GENDER NEUTRAL TOILET ROOMS. INSTRUCTED TO PROVIDE FOR DISPOSAL OF FEMININE PRODUCTS. \| 55. PHYSICAL FACILITIES INSTALLED, MAINTAINED & CLEAN - Comments: OBSERVED THE FOLLOWING IN NEED OF CLEANING: THE CREVICES OF THE WALLBASES THROUGHOUT REAR FOOD PREP AREA ESPECIALLY UNDER THE HOT HOLDING EQUIPMENT, THE FLOOR INSIDE THE WALK-IN COOLER, WALLS UNDER THE THREE COMPARTMENT SINK AND ON THE SIDE OF THE HOT HOLDING EQUIPMENT. INSTRUCTED TO CLEAN AND MAINTAIN.
4th row	10. ADEQUATE HANDWASHING SINKS PROPERLY SUPPLIED AND ACCESSIBLE - Comments: OBSERVED TOILET ROOM CLOSEST TO DINING AREA HANDWASHING SINK NOT ABLE TO RUN WATER WITHOUT LETTING GO OF MIXED WATER KNOB.INSTRUCTED TO REPAIR AND ENSURE SINK CAN RUN ATLEAST 15 SECONDS WITHOUT REACTIVATING WATER AND BEING ABLE ADEQUATELY WASH BOTH HANDS. \| 53. TOILET FACILITIES: PROPERLY CONSTRUCTED, SUPPLIED, & CLEANED - Comments: OBSERVED EMPLOYEE LOCKER ROOM WITH A TOILET AND HANDWASHING SINK WITH A DOOR THAT IS NOT SELF CLOSING. INSTRUCTED TO REPAIR AND MAINTAIN.
5th row	22. PROPER COLD HOLDING TEMPERATURES - Comments: OBSERVED IMPROPER COLD HOLDING TEMPERATURES OF TCS FOODS STORED INSIDE THE REFRIGERATOR AT THE FRONT PREP/SERVICE AREA. 10 CARTONS OF HEAVY WHIPPING CREAM FOUND AT 56.8F-60.0F AND CHEDDAR CHEESE FOUND AT 50.6F. MANAGER DISCARDED APPROXIMATELY 14LBS AT $100 WORTH OF PRODUCT. MUST HAVE COLD HOLDING FOODS AT 41.0F OR BELOW. PRIORITY 7-38-005, CITATION ISSUED \| 33. PROPER COOLING METHODS USED; ADEQUATE EQUIPMENT FOR TEMPERATURE CONTROL - Comments: OBSERVED AN IMPROPER TEMPERATURE OF A REFRIGERATOR AT 50.9F WITH TCS FOODS STORED INSIDE FOR SALE. A HELD FOR INSPECTION TAG PLACED ON THE UNIT. ONCE REPAIRED, PLEASE REVIEW COMMENTS FOR TAG REMOVAL. MUST HAVE COLD HOLDING UNITS AT 41.0F OR BELOW. PRIORITY 7-38-005, CITATION ISSUSED \| 38. INSECTS, RODENTS, & ANIMALS NOT PRESENT - Comments: OBSERVED THE FRONT ENTRANCE DOOR SWEEP SLIGHTLY DAMAGED AT THE BOTTOM THE RIGHT SIDE OF THE DOOR. INSTRUCTED TO REPAIR AND MAINTAN. \| 44. UTENSILS, EQUIPMENT & LINENS: PROPERLY STORED, DRIED, & HANDLED - Comments: OBSERVED CLEAR FOOD STORAGE CONTAINERS NOT INVERTED ON THE LOWER SHELF NEXT TO THE THREE COMPARTMENT SINK. INSTRUCTED TO INVERT AND MAINTAIN. \| 58. ALLERGEN TRAINING AS REQUIRED - Comments: OBSERVED THE MANAGER ON SITE WITH NO ALLERGEN TRAINING CERTIFICATE ON SITE. INSTRUCTED ALL CERTIFIED FOOD MANAGERS MUST TAKE ALLERGEN COURSE AND MAINTAIN RECORDS ON SITE.

Value	Count	Frequency (%)
	21080	6.5%
and	11513	3.6%
to	8615	2.7%
comments	8427	2.6%
the	7888	2.4%
in	7725	2.4%
food	6071	1.9%
instructed	5771	1.8%
observed	5628	1.7%
of	5337	1.6%
Other values (7154)	236209	72.8%

Most occurring characters

Value	Count	Frequency (%)
	327251	15.3%
E	185937	8.7%
N	135738	6.3%
A	135643	6.3%
I	134895	6.3%
O	132036	6.2%
T	130970	6.1%
R	112558	5.3%
S	101241	4.7%
D	86080	4.0%
Other values (73)	657491	30.7%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	2139840	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
	327251	15.3%
E	185937	8.7%
N	135738	6.3%
A	135643	6.3%
I	134895	6.3%
O	132036	6.2%
T	130970	6.1%
R	112558	5.3%
S	101241	4.7%
D	86080	4.0%
Other values (73)	657491	30.7%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	2139840	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
	327251	15.3%
E	185937	8.7%
N	135738	6.3%
A	135643	6.3%
I	134895	6.3%
O	132036	6.2%
T	130970	6.1%
R	112558	5.3%
S	101241	4.7%
D	86080	4.0%
Other values (73)	657491	30.7%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	2139840	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
	327251	15.3%
E	185937	8.7%
N	135738	6.3%
A	135643	6.3%
I	134895	6.3%
O	132036	6.2%
T	130970	6.1%
R	112558	5.3%
S	101241	4.7%
D	86080	4.0%
Other values (73)	657491	30.7%

Latitude
Real number (ℝ)

Distinct	1957
Distinct (%)	68.4%
Missing	12
Missing (%)	0.4%
Infinite	0
Infinite (%)	0.0%
Mean	41.882406

Minimum	41.662677
Maximum	42.021064
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	22.6 KiB

Quantile statistics

Minimum	41.662677
5-th percentile	41.719478
Q1	41.82287
median	41.895796
Q3	41.94712
95-th percentile	41.997661
Maximum	42.021064
Range	0.35838698
Interquartile range (IQR)	0.12424953

Descriptive statistics

Standard deviation	0.084480542
Coefficient of variation (CV)	0.002017089
Kurtosis	-0.54767721
Mean	41.882406
Median Absolute Deviation (MAD)	0.056407192
Skewness	-0.59455028
Sum	119909.33
Variance	0.007136962
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
41.88945828	33	1.1%
42.00875077	23	0.8%
41.97234928	9	0.3%
41.85045102	9	0.3%
41.89214078	7	0.2%
41.75032239	6	0.2%
41.8839051	6	0.2%
41.80030387	6	0.2%
41.96825393	5	0.2%
41.91072929	5	0.2%
Other values (1947)	2754	95.8%
(Missing)	12	0.4%

Value	Count	Frequency (%)
41.66267727	1	< 0.1%
41.66737294	2	0.1%
41.67044238	1	< 0.1%
41.67747786	1	< 0.1%
41.6775919	2	0.1%
41.67761706	2	0.1%
41.68194036	1	< 0.1%
41.68293421	2	0.1%
41.68300249	1	< 0.1%
41.68399182	1	< 0.1%

Value	Count	Frequency (%)
42.02106425	2	0.1%
42.02086075	1	< 0.1%
42.02080848	1	< 0.1%
42.01942097	2	0.1%
42.01942088	4	0.1%
42.01926996	1	< 0.1%
42.01920331	1	< 0.1%
42.0190979	1	< 0.1%
42.01865151	2	0.1%
42.01721933	2	0.1%

Longitude
Real number (ℝ)

Distinct	1957
Distinct (%)	68.4%
Missing	12
Missing (%)	0.4%
Infinite	0
Infinite (%)	0.0%
Mean	-87.684834

Minimum	-87.906874
Maximum	-87.525094
Zeros	0
Zeros (%)	0.0%
Negative	2863
Negative (%)	99.6%
Memory size	22.6 KiB

Quantile statistics

Minimum	-87.906874
5-th percentile	-87.799787
Q1	-87.721174
median	-87.674321
Q3	-87.641925
95-th percentile	-87.603671
Maximum	-87.525094
Range	0.38178
Interquartile range (IQR)	0.079249092

Descriptive statistics

Standard deviation	0.061451127
Coefficient of variation (CV)	-0.00070081819
Kurtosis	0.74067494
Mean	-87.684834
Median Absolute Deviation (MAD)	0.03895084
Skewness	-0.6298443
Sum	-251041.68
Variance	0.003776241
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-87.62036838	33	1.1%
-87.90687413	23	0.8%
-87.74682509	9	0.3%
-87.65879786	9	0.3%
-87.62431278	7	0.2%
-87.64418241	6	0.2%
-87.70605925	6	0.2%
-87.73174241	6	0.2%
-87.68817247	5	0.2%
-87.65315262	5	0.2%
Other values (1947)	2754	95.8%
(Missing)	12	0.4%

Value	Count	Frequency (%)
-87.90687413	23	0.8%
-87.90530913	1	< 0.1%
-87.86302998	1	< 0.1%
-87.84631989	2	0.1%
-87.8448585	1	< 0.1%
-87.84438867	1	< 0.1%
-87.84407563	3	0.1%
-87.83838526	1	< 0.1%
-87.8368381	1	< 0.1%
-87.83683755	1	< 0.1%

Value	Count	Frequency (%)
-87.52509414	1	< 0.1%
-87.52512485	2	0.1%
-87.5258717	2	0.1%
-87.52664793	1	< 0.1%
-87.52694018	1	< 0.1%
-87.52797024	1	< 0.1%
-87.53326501	1	< 0.1%
-87.53497435	1	< 0.1%
-87.53513166	1	< 0.1%
-87.53513677	1	< 0.1%

Location
Text

Distinct	1957
Distinct (%)	68.4%
Missing	12
Missing (%)	0.4%
Memory size	269.0 KiB

Length

Max length	40
Median length	39
Mean length	39.045756
Min length	35

Characters and Unicode

Total characters	111788
Distinct characters	16
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1310 ?
Unique (%)	45.8%

Sample

1st row	(41.84995400192252, -87.63209419559098)
2nd row	(41.85605269621059, -87.62731125804903)
3rd row	(41.97452873707269, -87.69233925845519)
4th row	(41.85666310572283, -87.64178573004398)
5th row	(41.83831568602238, -87.6340451596087)

Value	Count	Frequency (%)
41.88945828010943	33	0.6%
87.62036837642913	33	0.6%
87.90687413400109	23	0.4%
42.00875076599798	23	0.4%
87.65879785567869	9	0.2%
41.85045102427	9	0.2%
87.74682508578468	9	0.2%
41.97234928256036	9	0.2%
87.62431278442189	7	0.1%
41.892140783720365	7	0.1%
Other values (3904)	5564	97.2%

Most occurring characters

Value	Count	Frequency (%)
8	11543	10.3%
7	11366	10.2%
4	10599	9.5%
1	9889	8.8%
6	9438	8.4%
9	8784	7.9%
5	7945	7.1%
2	7651	6.8%
3	7546	6.8%
0	6986	6.2%
Other values (6)	20041	17.9%

Most occurring categories

Value	Count	Frequency (%)
(unknown)	111788	100.0%

Most frequent character per category

(unknown)

Value	Count	Frequency (%)
8	11543	10.3%
7	11366	10.2%
4	10599	9.5%
1	9889	8.8%
6	9438	8.4%
9	8784	7.9%
5	7945	7.1%
2	7651	6.8%
3	7546	6.8%
0	6986	6.2%
Other values (6)	20041	17.9%

Most occurring scripts

Value	Count	Frequency (%)
(unknown)	111788	100.0%

Most frequent character per script

(unknown)

Value	Count	Frequency (%)
8	11543	10.3%
7	11366	10.2%
4	10599	9.5%
1	9889	8.8%
6	9438	8.4%
9	8784	7.9%
5	7945	7.1%
2	7651	6.8%
3	7546	6.8%
0	6986	6.2%
Other values (6)	20041	17.9%

Most occurring blocks

Value	Count	Frequency (%)
(unknown)	111788	100.0%

Most frequent character per block

(unknown)

Value	Count	Frequency (%)
8	11543	10.3%
7	11366	10.2%
4	10599	9.5%
1	9889	8.8%
6	9438	8.4%
9	8784	7.9%
5	7945	7.1%
2	7651	6.8%
3	7546	6.8%
0	6986	6.2%
Other values (6)	20041	17.9%

	City	Facility Type	Inspection ID	Inspection Type	Latitude	License #	Longitude	Results	Risk	Zip
City	1.000	0.000	0.024	0.076	0.060	0.000	0.017	0.000	0.000	0.051
Facility Type	0.000	1.000	0.066	0.149	0.112	0.224	0.091	0.098	0.332	0.144
Inspection ID	0.024	0.066	1.000	0.073	-0.052	0.033	-0.006	0.043	0.022	0.018
Inspection Type	0.076	0.149	0.073	1.000	0.041	0.189	0.060	0.459	0.241	0.069
Latitude	0.060	0.112	-0.052	0.041	1.000	-0.014	-0.456	0.060	0.099	0.271
License #	0.000	0.224	0.033	0.189	-0.014	1.000	0.027	0.110	0.138	-0.037
Longitude	0.017	0.091	-0.006	0.060	-0.456	0.027	1.000	0.069	0.068	-0.461
Results	0.000	0.098	0.043	0.459	0.060	0.110	0.069	1.000	0.150	0.063
Risk	0.000	0.332	0.022	0.241	0.099	0.138	0.068	0.150	1.000	0.065
Zip	0.051	0.144	0.018	0.069	0.271	-0.037	-0.461	0.063	0.065	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

	Inspection ID	DBA Name	AKA Name	License #	Facility Type	Risk	Address	City	State	Zip	Inspection Date	Inspection Type	Results	Violations	Latitude	Longitude	Location
0	2609909	HAPPY MARKET	HAPPY MARKET	2912802.0	Grocery Store	Risk 2 (Medium)	2334 S WENTWORTH AVE	CHICAGO	IL	60616.0	2025-01-02	Canvass	Pass w/ Conditions	2. CITY OF CHICAGO FOOD SERVICE SANITATION CERTIFICATE - Comments: UPON ARRIVAL, OBSERVED NO CITY OF CHICAGO CERTIFIED FOOD MANAGER ON SITE WHILE OPEN AND OPERATING. INSTRUCTED A CITY OF CHICAGO CERTIFIED FOOD MANAGER MUST BE ON SITE AT ALL TIMES WHILE OPEN AND OPERATING. PRIORITY FOUNDATION VIOLATION 7-38-012, CITATION ISSUED \| 10. ADEQUATE HANDWASHING SINKS PROPERLY SUPPLIED AND ACCESSIBLE - Comments: 6-301.14: OBSERVED NO HANDWASHING SIGNS AT EXPOSED HANDSINK IN THE BASEMENT OR IN EMPLOYEE WASHROOM; INSTRUCTED TO PROVIDE. \| 38. INSECTS, RODENTS, & ANIMALS NOT PRESENT - Comments: 6-501.112: OBSERVED DEAD ROACHES INSIDE THE MOP SINK BASIN IN THE BUTCHER AREA, STICKY TRAPS IN BASEMENT FLOORS, ON THE WALL NEAR THE HOOD IN THE BASEMENT PREP AREA. INSTRUCTED TO REMOVE DEAD ROACHES AND MAINTAIN. \| 49. NON-FOOD/FOOD CONTACT SURFACES CLEAN - Comments: OBSERVED SHELF UNDER FOOD PREP TABLE BEHIND BUTCHER AREA WITH RUST. ALSO, OBSERVED DEBRIS ON THE SHELVES IN THE SHOPPING AISLES. INSTRUCTED TO REMOVE RUST AND DEBRIS AND MAKE SURFACE SMOOTH AND EASILY CLEANABLE.	41.849954	-87.632094	(41.84995400192252, -87.63209419559098)
1	2609927	SAT KAIVAL FOOD INC/SUBWAY	SAT KAIVAL FOOD INC/SUBWAY	2728400.0	Restaurant	Risk 1 (High)	1916 S STATE ST	CHICAGO	IL	60616.0	2025-01-02	Canvass	Pass	36. THERMOMETERS PROVIDED & ACCURATE - Comments: OBSERVED NO AMBIENT AIR THERMOMETER INSIDE THE COLD HOLDING UNITS ON SITE. INSTRUCTED TO PROVIDE AND MAINTAIN. \| 53. TOILET FACILITIES: PROPERLY CONSTRUCTED, SUPPLIED, & CLEANED - Comments: OBSERVED THE TOILET SEAT AND TOILET FIXTURES IN THE WOMEN'S TOILET ROOM IN NEED OF CLEANING. DRIED BODILY FLUID OBSERVED ON THE MENTIONED FIXTURES. INSTRUCTED TO CLEAN AND MAINTAIN.	41.856053	-87.627311	(41.85605269621059, -87.62731125804903)
2	2610482	DANCEN GRILL RESTAURANT, INC.	DANCEN	2341747.0	Restaurant	Risk 1 (High)	5114 N LINCOLN AVE	CHICAGO	IL	60625.0	2025-01-14	Non-Inspection	No Entry	NaN	41.974529	-87.692339	(41.97452873707269, -87.69233925845519)
3	2610081	MARYS TAQUERIA AND GROCERY STORE, INC.	MARYS FOOD AND GROCERY STORE	2326530.0	Restaurant	Risk 1 (High)	1901 S CANALPORT AVE	CHICAGO	IL	60616.0	2025-01-06	Canvass	Pass	10. ADEQUATE HANDWASHING SINKS PROPERLY SUPPLIED AND ACCESSIBLE - Comments: OBSERVED NO HANDWASHING SIGNAGE AT THE HANDWASHING SINK NEAR THE THREE COMPARTMENT SINK IN THE REAR. INSTRUCTED TO PROVIDE AND MAINTAIN. \| 47. FOOD & NON-FOOD CONTACT SURFACES CLEANABLE, PROPERLY DESIGNED, CONSTRUCTED & USED - Comments: OBSERVED THE LOWER SHELVES UNDER THE FOOD PREP TABLES IN THE REAR FOOD PREP AREA WITH SLIGHT DEBRIS. INSTRUCTED TO REMOVE DEBRIS AND MAINTAIN. \| 51. PLUMBING INSTALLED; PROPER BACKFLOW DEVICES - Comments: OBSERVED NO BACKFLOW PREVENTION DEVICE ON THE ICE MACHINE IN THE REAR FOOD PREP AREA. INSTRUCTED TO INSTALL AN ADEQUATE BACKFLOW PREVENTION DEVICE ON THE ICE MACHINE. \| 53. TOILET FACILITIES: PROPERLY CONSTRUCTED, SUPPLIED, & CLEANED - Comments: OBSERVED NO LID FOR GARBAGE RECEPTACLE IN GENDER NEUTRAL TOILET ROOMS. INSTRUCTED TO PROVIDE FOR DISPOSAL OF FEMININE PRODUCTS. \| 55. PHYSICAL FACILITIES INSTALLED, MAINTAINED & CLEAN - Comments: OBSERVED THE FOLLOWING IN NEED OF CLEANING: THE CREVICES OF THE WALLBASES THROUGHOUT REAR FOOD PREP AREA ESPECIALLY UNDER THE HOT HOLDING EQUIPMENT, THE FLOOR INSIDE THE WALK-IN COOLER, WALLS UNDER THE THREE COMPARTMENT SINK AND ON THE SIDE OF THE HOT HOLDING EQUIPMENT. INSTRUCTED TO CLEAN AND MAINTAIN.	41.856663	-87.641786	(41.85666310572283, -87.64178573004398)
4	2610172	KOTO	KOTO	2872350.0	Restaurant	Risk 1 (High)	258 W 31ST ST	CHICAGO	IL	60616.0	2025-01-07	Canvass	Pass	10. ADEQUATE HANDWASHING SINKS PROPERLY SUPPLIED AND ACCESSIBLE - Comments: OBSERVED TOILET ROOM CLOSEST TO DINING AREA HANDWASHING SINK NOT ABLE TO RUN WATER WITHOUT LETTING GO OF MIXED WATER KNOB.INSTRUCTED TO REPAIR AND ENSURE SINK CAN RUN ATLEAST 15 SECONDS WITHOUT REACTIVATING WATER AND BEING ABLE ADEQUATELY WASH BOTH HANDS. \| 53. TOILET FACILITIES: PROPERLY CONSTRUCTED, SUPPLIED, & CLEANED - Comments: OBSERVED EMPLOYEE LOCKER ROOM WITH A TOILET AND HANDWASHING SINK WITH A DOOR THAT IS NOT SELF CLOSING. INSTRUCTED TO REPAIR AND MAINTAIN.	41.838316	-87.634045	(41.83831568602238, -87.6340451596087)
5	2610336	SHARKS FISH-CHICKEN	SHARKS FISH-CHICKEN	2079668.0	Restaurant	Risk 2 (Medium)	250-252 E 35TH ST	CHICAGO	IL	60616.0	2025-01-10	Canvass	Out of Business	NaN	41.831187	-87.619788	(41.831187404696436, -87.61978768516512)
6	2611120	Big Hill Cantina	Big Hill Bar & Grill	1678004.0	Restaurant	Risk 1 (High)	3307 W BRYN MAWR AVE	CHICAGO	IL	60659.0	2025-01-27	Non-Inspection	No Entry	NaN	41.982925	-87.711613	(41.982925247986955, -87.71161308569827)
7	2610622	JEWEL-OSCO #3181	JEWEL-OSCO	2977880.0	Grocery Store	Risk 3 (Low)	87 W 87TH ST	CHICAGO	IL	60620.0	2025-01-15	Canvass	Out of Business	NaN	41.736145	-87.626918	(41.7361451282369, -87.62691784397349)
8	2610361	MOMENTUM COFFEE	MOMENTUM COFFEE	2708683.0	Restaurant	Risk 1 (High)	2119 S STATE ST	CHICAGO	IL	60616.0	2025-01-13	Canvass	Pass w/ Conditions	22. PROPER COLD HOLDING TEMPERATURES - Comments: OBSERVED IMPROPER COLD HOLDING TEMPERATURES OF TCS FOODS STORED INSIDE THE REFRIGERATOR AT THE FRONT PREP/SERVICE AREA. 10 CARTONS OF HEAVY WHIPPING CREAM FOUND AT 56.8F-60.0F AND CHEDDAR CHEESE FOUND AT 50.6F. MANAGER DISCARDED APPROXIMATELY 14LBS AT $100 WORTH OF PRODUCT. MUST HAVE COLD HOLDING FOODS AT 41.0F OR BELOW. PRIORITY 7-38-005, CITATION ISSUED \| 33. PROPER COOLING METHODS USED; ADEQUATE EQUIPMENT FOR TEMPERATURE CONTROL - Comments: OBSERVED AN IMPROPER TEMPERATURE OF A REFRIGERATOR AT 50.9F WITH TCS FOODS STORED INSIDE FOR SALE. A HELD FOR INSPECTION TAG PLACED ON THE UNIT. ONCE REPAIRED, PLEASE REVIEW COMMENTS FOR TAG REMOVAL. MUST HAVE COLD HOLDING UNITS AT 41.0F OR BELOW. PRIORITY 7-38-005, CITATION ISSUSED \| 38. INSECTS, RODENTS, & ANIMALS NOT PRESENT - Comments: OBSERVED THE FRONT ENTRANCE DOOR SWEEP SLIGHTLY DAMAGED AT THE BOTTOM THE RIGHT SIDE OF THE DOOR. INSTRUCTED TO REPAIR AND MAINTAN. \| 44. UTENSILS, EQUIPMENT & LINENS: PROPERLY STORED, DRIED, & HANDLED - Comments: OBSERVED CLEAR FOOD STORAGE CONTAINERS NOT INVERTED ON THE LOWER SHELF NEXT TO THE THREE COMPARTMENT SINK. INSTRUCTED TO INVERT AND MAINTAIN. \| 58. ALLERGEN TRAINING AS REQUIRED - Comments: OBSERVED THE MANAGER ON SITE WITH NO ALLERGEN TRAINING CERTIFICATE ON SITE. INSTRUCTED ALL CERTIFIED FOOD MANAGERS MUST TAKE ALLERGEN COURSE AND MAINTAIN RECORDS ON SITE.	41.853650	-87.626956	(41.85364982727399, -87.62695608899325)
9	2612125	LURE FISHBAR CHICAGO	LURE FISHBAR	2718512.0	Restaurant	Risk 1 (High)	616 N RUSH ST	CHICAGO	IL	60611.0	2025-02-11	Canvass	Pass	55. PHYSICAL FACILITIES INSTALLED, MAINTAINED & CLEAN - Comments: OBSERVED MISSING AND DAMAGED FLOOR TILES IN ENTIRE REAR PREP/ DISH AREA AND THE HALL TOWARDS TOILET ROOMS. NOTED DISH AREA AND REAR PREP FLOOR GROUT IS NEEDED. INSTRUCTED TO REPAIR TO CREATE A SMOOTH AND EASILY CLEANABLE SURFACE. MUST MAINTAIN AT ALL TIMES. \| 55. PHYSICAL FACILITIES INSTALLED, MAINTAINED & CLEAN - Comments: OBSERVED CHIPPED PAINT ON THE WALLS IN THE KITCHEN AND SUSHI AREA. INSTRUCTED TO RESURFACE AND REPAINT CHIPPED AREAS TO ENSURE WALLS ARE SEALED, SMOOTH AND EASILY CLEANABLE. \| 55. PHYSICAL FACILITIES INSTALLED, MAINTAINED & CLEAN - Comments: OBSERVED IN DISH AREA 3 COMPARMENT SINK, THE 3RD BASIN NOT HOLDING WATER WITH STOPPER. NOTED 1 COMPARMENT SINK IN REAR BEVERAGE STATION LEAKING FROM DRAINPIPE. INSTRUCTED TO REPAIR AND MAINTAIN.	41.893131	-87.625559	(41.89313081087328, -87.62555906428202)

	Inspection ID	DBA Name	AKA Name	License #	Facility Type	Risk	Address	City	State	Zip	Inspection Date	Inspection Type	Results	Violations	Latitude	Longitude	Location
2865	2610834	GIORDANO'S PIZZA	GIORDANO'S PIZZA	35634.0	Restaurant	Risk 1 (High)	5927 W IRVING PARK RD	CHICAGO	IL	60634.0	2025-01-22	Non-Inspection	No Entry	NaN	41.952962	-87.775414	(41.95296188094511, -87.77541370832724)
2866	2610022	TACO BELL CANTINA	TACO BELL	2831664.0	Restaurant	Risk 1 (High)	1160 N CLARK ST	CHICAGO	IL	60610.0	2025-01-06	Canvass	Pass	39. CONTAMINATION PREVENTED DURING FOOD PREPARATION, STORAGE & DISPLAY - Comments: OBSERVED BOXES OF FROZEN PRODUCTS ON THE FLOOR OF THE WALK IN FREEZER LOCATED IN THE BASEMENT OF THE FACILITY. INSTRUCTED TO REMOVE AND KEEP ITEMS LIFTED OFF THE FLOOR ELEVATED AT LEAST SIX INCHES. \| 47. FOOD & NON-FOOD CONTACT SURFACES CLEANABLE, PROPERLY DESIGNED, CONSTRUCTED & USED - Comments: OBSERVED A BUILD UP OF DIRT AND DEBRIS UNDER AND AROUND THE SLUSHY STATION AS WELL AS THE BEVERAGE STATION. INSTRUCTED TO CLEAN AND MAINTAIN AREAS AS NEEDED. \| 55. PHYSICAL FACILITIES INSTALLED, MAINTAINED & CLEAN - Comments: OBSERVED THE FLOORS IN THE FRONT AND REAR OF THE FACILITY WITH A BUILD UP OF DIRT AND SMALL DEBRIS UNDER EQUIPMENT ALONG THE CORNERS OF THE WALLS AND SPILLAGE ON THE FLOOR UNDER THE SODA MACHINE IN THE FRONT SERVICE AREA. INSTRUCTED TO CLEAN AND MAINTAIN ALL AREAS AS A MEANS OF PREVENTING POSSIBLE PEST AND OR INSECT ACTIVITY.	41.903609	-87.631583	(41.903609451824686, -87.63158311098476)
2867	2610538	FADO IRISH PUB	FADO IRISH PUB	53945.0	Restaurant	Risk 1 (High)	100 W GRAND AVE	CHICAGO	IL	60610.0	2025-01-14	Non-Inspection	No Entry	NaN	41.891735	-87.631202	(41.891735020379166, -87.63120168879202)
2868	2610806	HILTON O'HARE	HILTON O'HARE/ANDIAMO'S/CAFFE MERCATO	2647047.0	Restaurant	Risk 1 (High)	11601 W TOUHY AVE	CHICAGO	IL	60666.0	2025-01-22	Canvass Re-Inspection	Pass	43. IN-USE UTENSILS: PROPERLY STORED - Comments: NOTED SERVING PLATES ON SHELVES AT THE DISH WASHING AREA NOT PROPERLY STORED. INSTRUCTED TO INVERT ALL SERVING PLATES TO PREVENT DUST ACCUMULATION. \| 47. FOOD & NON-FOOD CONTACT SURFACES CLEANABLE, PROPERLY DESIGNED, CONSTRUCTED & USED - Comments: NOTED CUTTING BOARDS WITH OPEN SEAMS AND DARK STAINS AT THE KITCHEN PREP AREA. MUST REFINISH OR REPLACE DAMAGED OR STAINED CUTTING BOARDS. \| 49. NON-FOOD/FOOD CONTACT SURFACES CLEAN - Comments: NOTED A SLIMY AND GREY SUBSTANCE INSIDE THE SODA GUN DISPENSER AT THE BAR. INSTRUCTED TO CLEAN, SANITIZE AND MAINTAIN. \| 55. PHYSICAL FACILITIES INSTALLED, MAINTAINED & CLEAN - Comments: INSTRUCTED TO CLEAN FLOORS, AND FLOOR DRAINS ESPECIALLY AT THE DISH WASHING AREA, THE BAR AND THE MIDDLE PREP AREA AT THE KITCHEN.	42.008751	-87.906874	(42.00875076599798, -87.90687413400109)
2869	2610859	MOY LEE	MOY LEE	2877054.0	Restaurant	Risk 1 (High)	5346 N MILWAUKEE AVE	CHICAGO	IL	60630.0	2025-01-22	Complaint	Pass	NaN	41.977764	-87.769830	(41.97776393135019, -87.76982985082259)
2870	2610937	DAPPER'S EAST RESTAURANT	DAPPER'S EAST RESTAURANT	12540.0	Restaurant	Risk 1 (High)	2901 W ADDISON ST	CHICAGO	IL	60618.0	2025-01-23	Complaint Re-Inspection	Pass	47. FOOD & NON-FOOD CONTACT SURFACES CLEANABLE, PROPERLY DESIGNED, CONSTRUCTED & USED - Comments: 4-202.16 OBSERVED RUST ON STROAGE SHELVES IN THE WALK-IN COOLER AND WALK-IN FREEZER IN THE REAR PREP AREA. INSTRUCTED THE PERSON IN CHARGE TO REMOVE RUST AND ENSURE ALL NONFOOD-CONTACT SURFACES REMAIN SMOOTH AND EASILY CLEANABLE. \| 49. NON-FOOD/FOOD CONTACT SURFACES CLEAN - Comments: 4-602.13 OBSERVED ACCUMULATED FOOD FOOD DEBRIS ON INTERIOR SURFACES OF ALL COLD HOLDING EQUIPMENT IN REAR PREP AREAS. INSTRUCTED THE PERSON IN CHARGE TO DETAIL CLEAN AND MAINTAIN.	41.946553	-87.700536	(41.94655282616904, -87.700535765616)
2871	2610845	SHARPIE'S	SHARPIE'S	3002203.0	Restaurant	Risk 3 (Low)	1721 N ELSTON AVE	CHICAGO	IL	60642.0	2025-01-22	License	Not Ready	NaN	41.913729	-87.664223	(41.91372879440366, -87.66422290709808)
2872	2610409	ACE SUSHI @POTASH MARKET	ACE SUSHI	2808766.0	Restaurant	Risk 1 (High)	875 N STATE ST	CHICAGO	IL	60610.0	2025-01-13	Canvass	Pass	55. PHYSICAL FACILITIES INSTALLED, MAINTAINED & CLEAN - Comments: OBSERVED SMALL DEBRIS ON FLOOR IN PREP AREA. INSTRUCTED TO CLEAN AND MAINTAIN AREA. \| 58. ALLERGEN TRAINING AS REQUIRED - Comments: OBSERVED NOT ALLERGEN TRAINING CERTIFICATE ON SITE FOR TU CHIN LIAN. INSTRUCTED TO OBTAIN AND PROVIDE ON SITE.	41.898878	-87.628111	(41.89887819742381, -87.6281111483033)
2873	2610823	Kitchen Chicago, LLC	Kitchen Chicago, LLC	2119905.0	Shared Kitchen	Risk 1 (High)	324 N LEAVITT ST	CHICAGO	IL	60612.0	2025-01-22	Canvass	Pass	49. NON-FOOD/FOOD CONTACT SURFACES CLEAN - Comments: CLEAN THE STORAGE SHELVES IN ZELLA'S STORAGE CLOSET. CLEAN THE PREP TABLE UNDERNEATH THE GRILL IN THE EAST PREP AREA. CLEAN THE TOP OF THE DISHMACHINE. \| 55. PHYSICAL FACILITIES INSTALLED, MAINTAINED & CLEAN - Comments: CLEAN THE FLOOR IN ZELLA'S STORAGE CLOSET. CLEAN THE WALLS BEHIND THE GRILL AND STOVE IN THE EAST AND WEST PREP AREAS. REPAINT THE WALL NEXT TO THE GRILL IN THE EAST PREP AREA WHERE THE PAINT IS CHIPPED.	41.887434	-87.681849	(41.88743405025222, -87.68184949426895)
2874	2610068	HANNAH'S BRETZEL 227 W. MONROE LLC	HANNAH'S BRETZEL	2428372.0	Restaurant	Risk 1 (High)	227 W MONROE ST	CHICAGO	IL	60606.0	2025-01-06	Canvass	Pass	37. FOOD PROPERLY LABELED; ORIGINAL CONTAINER - Comments: Water spray bottles not labeled, Instructed to label.	41.880539	-87.634592	(41.88053924995021, -87.63459246351388)

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)

Most occurring blocks

Most frequent character per block

(unknown)

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

(unknown)

Most occurring scripts

Most frequent character per script

(unknown)